package com.personal.mapper;

import com.personal.pojo.TClassroom;
import com.personal.pojo.TClassroomExample;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface TClassroomMapper {
    int countByExample(TClassroomExample example);

    int deleteByExample(TClassroomExample example);

    //删除教室信息
    int deleteByPrimaryKey(Integer classroomid);

    //插入教室
    int insert(TClassroom record);

    int insertSelective(TClassroom record);

    //查询所有教室
    List<TClassroom> selectByExample();

    //根据id查
    TClassroom selectByPrimaryKey(Integer classroomid);

    int updateByExampleSelective(@Param("record") TClassroom record, @Param("example") TClassroomExample example);

    int updateByExample(@Param("record") TClassroom record, @Param("example") TClassroomExample example);

    //修改教室信息
    int updateByPrimaryKeySelective(TClassroom record);

    int updateByPrimaryKey(TClassroom record);
    //多条件查询教室
    List selectByCluase(@Param("classroomtype")String classroomtype,@Param("min") Integer min,@Param("max") Integer max,@Param("classroomName") String classroomName);
    //根据名字查询教室,模糊查询
    List findClassroom(String classroomname);
}